<?php

/**
 * This is the model class for table "{{product_lang}}".
 *
 * The followings are the available columns in table '{{product_lang}}':
 * @property integer $id
 * @property integer $productID
 * @property string $name
 * @property string $description
 * @property string $languageID
 */
class ProductLang extends CActiveRecord
{
  /**
   * Returns the static model of the specified AR class.
   * @param string $className active record class name.
   * @return ProductLang the static model class
   */
  public static function model($className=__CLASS__)
  {
    return parent::model($className);
  }

  /**
   * @return string the associated database table name
   */
  public function tableName()
  {
    return '{{product_lang}}';
  }

  /**
   * @return array validation rules for model attributes.
   */
  public function rules()
  {
    // NOTE: you should only define rules for those attributes that
    // will receive user inputs.
    return array(
    array('productID, name, languageID', 'required'),
    array('productID', 'numerical', 'integerOnly'=>true),
    array('name', 'length', 'max'=>200),
    array('languageID', 'length', 'max'=>2),
    // The following rule is used by search().
    // Please remove those attributes that should not be searched.
    array('id, productID, name, description, languageID', 'safe', 'on'=>'search'),
    );
  }

  /**
   * @return array relational rules.
   */
  public function relations()
  {
    // NOTE: you may need to adjust the relation name and the related
    // class name for the relations automatically generated below.
    return array(
		  'product' => array(self::BELONGS_TO, 'Product', 'productID'),
    );
  }

  /**
   * @return array customized attribute labels (name=>label)
   */
  public function attributeLabels()
  {
    return array(
			'id' => 'ID',
			'productID' => 'Product',
			'name' => 'Name',
			'description' => 'Description',
			'languageID' => 'Language',
    );
  }

  public function getName($productID) {
    $model = ProductLang::model()->findByAttributes(array('productID' => $productID, 'languageID' => Yii::app()->session['language']));
    if (!empty($model)) {
      return $model->name;
    } else {
      return 'N/A';
    }
  }

  public function getDescription($productID) {
    $model = ProductLang::model()->findByAttributes(array('productID' => $productID, 'languageID' => Yii::app()->session['language']));
    if (!empty($model)) {
      return $model->description;
    } else {
      return 'N/A';
    }
  }


  /**
   * Retrieves a list of models based on the current search/filter conditions.
   * @return CActiveDataProvider the data provider that can return the models based on the search/filter conditions.
   */
  public function search()
  {
    // Warning: Please modify the following code to remove attributes that
    // should not be searched.

    $criteria=new CDbCriteria;

    $criteria->compare('id',$this->id);
    $criteria->compare('productID',$this->productID);
    $criteria->compare('name',$this->name,true);
    $criteria->compare('description',$this->description,true);
    $criteria->compare('languageID',$this->languageID,true);

    return new CActiveDataProvider($this, array(
			'criteria'=>$criteria,
    ));
  }
}